SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104883 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104883 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528515,119371,77812,188121,768985,840507,300877,675587,160506,1021590,702529,344499,428190,1009528,902643,98051,199103,308361,336312,8801,125786,201679,326304,648353,10610,427887,619189,824439,481394,11780,678079,467410,837482,599377,771639,350628,686372,1037351,917685,178284,9607,857603,258384,302480,528159,498525,763644,622984,747166,70493,416814,420221,505778,114321,1002565,696354,1045325,452965,711046,534945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]