SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154450 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154450 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595852,1025646,611182,495566,946745,555740,81754,11034,45508,395919,1047933,900351,939718,491055,536913,948299,45001,970723,44501,718748,378646,252291,421610,474348,952467,119563,899280,28798,880021,353810,91905,1036387,923869,696088,76763,683137,213563,277356,266832,1000773,804904,42158,808608,712527,148142,817408,766634,100973,155480,680155,373673,623388,35929,525274,136643,11208,45744,192950,449461,761258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]