SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578821 LIMIT 1 [ RunTime:0.001914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578821 [ RunTime:0.003710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113971,1014690,952987,189062,529221,301465,6183,566569,12414,284139,124780,764438,551482,930988,1006440,541900,881266,383422,434309,741403,631436,216628,650044,670878,57584,852969,757218,596437,1009706,499986,565236,108064,887547,908346,138589,134926,421228,662115,99293,57406,1032919,195391,219807,1006030,675302,588321,520291,396676,651579,80365,973456,727500,111592,477815,811642,865767,530607,1020559,368794,151544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004218s ]