SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031006 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031006 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242059,133395,257851,992285,251903,1012864,399168,160005,515599,281104,549832,917495,995416,790068,173313,388752,674254,727653,872144,360300,299845,971135,252907,485399,279145,1048710,120871,711712,827799,506036,650224,545980,596554,706335,603949,238478,815267,409415,306968,675051,988376,419027,418761,156825,191387,12571,868334,200120,640421,500447,128765,167071,852315,776288,286180,270618,918640,97926,303890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]