SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805475 LIMIT 1 [ RunTime:0.002939s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805475 [ RunTime:0.006784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026410,418652,464254,61552,941305,510606,85193,223736,15128,998683,311170,10963,797326,494269,198452,880737,584980,939489,621400,424714,264120,727139,739207,593035,120410,574925,75430,121191,1010451,571499,722481,42491,442211,786081,386737,744813,299010,223561,397902,701714,910117,782181,77059,836290,565597,334517,139726,350615,59702,311271,224235,908955,571142,265045,944825,210626,237400,488626,917185,274830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]