SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557215 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557215 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220434,810226,242769,578994,548874,1037600,898853,751223,102928,972508,530590,292495,741717,591142,36323,13770,611456,790496,688080,260049,355886,941859,274416,646435,900408,1000742,512855,931660,603199,732902,356197,516294,284151,372063,969495,179123,609020,1010235,555327,28813,479465,566182,186606,529053,691727,194549,441386,904144,9943,852600,511814,340554,375656,795721,209877,947381,418709,409,847394,565134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]