SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44301 LIMIT 1 [ RunTime:0.001395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44301 [ RunTime:0.002623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355217,776272,86153,852605,994050,669438,545565,347787,425112,763528,455355,77028,113105,177003,762280,690167,707595,559983,608050,623448,973656,807198,58425,94167,277424,432241,940137,183897,571631,679883,1011565,824044,169848,605795,253147,754812,505927,331856,1014578,776056,81445,295340,506988,273035,779138,716728,114358,532703,653459,388911,817384,649048,432764,106312,917350,918673,978498,441269,671578,1029419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004584s ]