SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437941 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437941 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038000,527483,490053,33002,567506,664930,697871,475808,564259,24405,85828,114977,112719,86437,45756,1030653,950277,570961,726104,711295,60220,935237,1024491,11652,526786,438554,852378,817250,320703,673392,32208,652471,470032,653274,463108,621976,267906,192784,938964,445703,700018,20800,169291,305963,586242,243588,165430,56082,394961,379642,980131,594038,883559,437342,333636,587578,491596,856394,866004,75005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]