SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804760 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804760 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400197,120549,99250,698749,247407,331159,843191,293923,250120,649112,707601,899078,831056,770360,936736,554205,943462,445979,854858,126723,1012512,104159,266354,881650,762388,1034019,954093,989325,120048,465151,259520,939862,651730,299706,748408,860617,965011,133214,21733,414171,892745,607958,255355,825250,823342,657899,238428,809447,331893,766113,211482,79970,607616,254496,286636,199085,736356,993970,238177,230654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]