SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566272 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566272 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300859,47962,582553,353730,132659,839565,746073,925320,658697,328553,331782,339385,121508,401048,667657,514388,522365,288223,574023,455592,31467,348607,488673,298889,267604,244010,870570,1048261,923442,855902,989165,840429,724520,923210,620257,724434,1009940,421572,855113,253148,61478,508875,650904,723135,130994,60015,296580,844915,298936,668242,835555,351197,126753,118581,601112,817355,170110,961542,701947,960701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]