SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101685 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101685 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511970,43147,383536,189907,335106,542003,1036219,109764,476753,525071,129454,366062,495432,296984,198471,701706,109381,757020,299823,510570,124823,899040,60782,97873,711822,267024,169310,861326,825404,326129,817858,332000,402825,881676,96968,352515,754489,543651,589413,1016750,292081,251429,996312,864305,17256,736205,264471,766555,259639,748195,758292,401343,464593,470254,788796,71890,392586,425262,522675,574442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]