SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514815 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514815 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988676,436945,830714,714903,284261,451487,478472,178700,522401,884047,695854,216677,729542,72469,826637,913626,11,996852,1044373,781660,403461,699640,490209,633155,224732,864305,113586,855614,326162,510873,582835,406475,191572,299684,471008,884474,637898,508359,977389,209905,495966,1048681,247577,266344,155384,544378,492923,412858,735103,758395,678184,743384,456221,681846,139906,37073,297664,579014,298959,411493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]