SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 832800 LIMIT 1 [ RunTime:0.001330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 832800 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235597,279120,190454,818702,403524,396167,957783,979916,488161,558184,721252,464745,308213,982097,5408,466435,407978,21180,783202,178580,388551,179008,905023,44334,620167,346407,331990,837385,697292,427332,623056,267293,1028243,165042,895379,251371,589817,126852,400847,125067,656859,994694,481532,356392,785635,506073,1040996,277100,93437,954105,365784,38062,478463,501238,686602,165845,818399,2601,865708,941885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 832800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 832800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]