SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611331 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611331 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204118,700081,191516,515343,100022,1027136,78690,771731,36065,558112,178184,751610,651666,846334,730513,327260,142605,108016,727700,468858,157258,218261,805252,344312,214336,360971,346324,190026,196087,943993,442097,417846,254549,77134,820081,745413,906407,994027,729597,661519,457228,487354,914239,280692,319480,750439,1012887,199858,830886,708304,661295,612703,123396,1006925,724931,386978,813801,1008455,99507,283175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]