SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101087 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101087 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544745,32697,679832,689185,334,249928,973706,379671,198141,435399,701294,395582,185763,950396,879061,907738,179374,982546,94345,618574,547321,786275,117758,740474,952879,394316,255728,230647,439369,603726,93130,10093,869875,216215,436517,449851,1008833,987076,564286,1014545,607769,228485,151754,175057,306625,476589,64097,689115,902671,299063,940236,382879,1019516,614720,241843,717343,534856,734730,478099,754171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]