SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512704 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512704 [ RunTime:0.003901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798450,970002,351554,961619,91790,857363,742382,514037,152828,781751,536151,496358,536683,326648,86057,796145,172326,329752,200337,391885,923728,600798,664290,272033,655300,278230,251636,785756,800640,720008,139798,177270,718147,126476,734017,936179,333413,879747,260608,289104,75350,751487,14670,682979,845507,574165,49259,918252,238763,21670,721936,871171,864709,243438,73640,393514,866779,552105,473841,397982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001927s ]