SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535218 LIMIT 1 [ RunTime:0.002420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535218 [ RunTime:0.003313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285486,804556,529899,503452,332731,56442,574211,739834,544066,983394,868981,60702,264983,422289,140883,197915,474768,745556,426155,531136,556922,587018,424078,566966,620616,520475,73415,497139,386794,376366,321944,606472,501692,91794,548120,582176,408594,596965,1001339,322279,401612,250564,75180,336608,15248,739938,676606,318247,862681,38452,275687,53445,263545,434555,1022561,431762,945139,1030988,995861,1026415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003624s ]