SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108968 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108968 [ RunTime:0.003844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373509,441711,750882,572823,658897,440153,865485,890340,170263,394319,375890,1011536,931061,436595,802388,756928,217790,84167,769,91669,842923,320245,49637,111478,362427,322513,460448,439929,746978,153,260857,263314,413722,616464,136574,1045218,462061,1028627,112027,935052,158570,843520,86569,817781,408586,646722,774824,53928,877770,8783,699605,183153,455475,391290,345672,81723,457514,494705,960217,752922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]