SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364312 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364312 [ RunTime:0.002660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154713,393597,573395,668013,1044588,312646,963344,981393,580519,200247,684232,367616,121699,778026,95915,451158,958899,54711,110680,553171,815230,643574,695045,928467,435880,414340,129770,7381,781207,720068,330155,511321,269157,604216,264796,547314,993522,259269,543415,1038738,639682,624813,139693,1012044,11961,9193,457682,426252,255597,304188,950848,840494,627451,421169,252513,1009729,479103,1038230,199913,823089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]