SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601605 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601605 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515102,75729,467899,430196,778316,839251,509419,542099,779338,6513,133807,107156,898483,365169,877339,709140,299132,985239,8919,767553,1025152,946297,888167,642951,499074,443012,877823,226329,753397,436243,763435,480889,819594,574650,195735,263209,401322,41659,492873,80990,894450,572501,270690,741081,595519,368711,356585,646449,563716,362645,592462,848813,501932,234383,507281,1037278,905134,16816,961984,710253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]