SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034429 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034429 [ RunTime:0.002627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666385,949523,380062,226792,1025820,132090,1045154,267050,819559,1047532,86268,616833,195840,827740,39879,590484,403108,287817,681887,361402,420136,540562,288687,544017,65468,615027,495028,9150,111649,253974,262200,581912,529238,1017801,703539,884215,1022086,605452,587933,288466,849786,357837,106465,896053,725656,822455,873208,180527,383256,153874,975971,734745,255925,416999,69692,979918,115043,385436,135041,432583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001423s ]