SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540910 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540910 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268056,682049,561154,476325,847142,320510,827002,883258,814768,732127,831221,172874,650389,438666,923243,199745,481185,394627,241160,401780,229691,546989,451918,320379,118622,584406,138477,76819,9090,609806,642067,332618,13344,300165,168339,581151,678268,372844,75460,220612,522446,117936,913007,895347,345206,294024,1011097,95568,847186,979934,849657,444340,516496,174012,789873,83856,253233,977143,1048383,954508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]