SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526058 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526058 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150539,741937,363030,1006123,747477,640560,73432,611210,305240,517392,159750,818767,98186,154722,487314,361782,343171,81450,606376,485431,400757,548702,222629,543849,973344,74161,413969,251419,844568,934638,564071,590407,330941,458601,746318,406848,475324,9088,878667,895223,980407,599427,257189,353672,830795,85568,785910,262380,833096,170181,156459,267602,529915,293182,1015786,606532,258688,504964,1047311,788842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002096s ]