SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38054 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38054 [ RunTime:0.003340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344691,613458,922621,877435,661632,352787,810022,219019,469976,509751,555168,864582,437844,863047,11659,832204,572654,625428,841306,497115,100364,16114,605970,194286,25846,386516,996840,505340,1033356,632954,1016880,387463,2389,386368,977386,72313,576954,411809,161682,847813,199556,250524,1009421,985707,354745,90067,170904,789387,406175,247632,571831,1004511,379048,605562,516413,421452,570344,982705,752881,448821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]