SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513288 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513288 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938162,485841,414829,610369,111477,395152,888389,177968,510442,199441,891571,104920,349673,616799,794076,404324,90119,890132,123910,669709,1012564,955058,25419,551546,184850,805549,633430,117034,257032,24517,630543,975123,880653,1021788,63393,920968,42684,37968,408981,602112,1017660,495645,235481,87047,163063,544071,527409,856113,963644,172377,147594,724725,43905,440591,1023844,264803,661728,475160,274205,856750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]