SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456575 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456575 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130904,685011,299197,605101,734051,402963,812790,476903,307518,553757,429579,952192,224222,103120,774588,422179,290298,270454,729781,383071,1028904,173860,989217,923600,140069,177114,963843,85395,363266,20116,769079,910271,295,311972,118220,635141,1042165,596018,605362,323711,530377,451038,497524,55636,908656,752663,238578,365110,116461,88638,1043178,132154,124629,699941,696516,1001818,459724,936375,182547,987355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]