SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022924 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022924 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673507,658411,450267,794127,883256,359776,953866,196083,423849,62337,645794,278090,18030,3713,85448,458054,534149,868946,674202,225209,224356,209392,212202,734159,1002391,824266,1015075,352345,558129,516725,599726,730117,329267,781229,28279,887120,954305,1011841,419785,389396,206551,124739,666761,742509,601577,895111,629024,194902,956060,749445,869581,703478,958971,793830,523008,1048176,602254,798233,88268,1002861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001882s ]