SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565946 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565946 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4521,839212,204897,323805,188052,63748,901075,158827,829791,927248,347684,344283,590541,483159,675630,18098,814839,946027,108346,245345,173810,768131,450499,637707,731551,749770,391378,195929,616846,9572,294481,588588,592879,815854,291766,323656,946774,104972,25441,72861,704455,66828,361104,742232,32051,186260,578591,304739,756412,819874,740124,663149,40427,666168,431956,428559,652854,626108,57769,464314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001068s ]