SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455423 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455423 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609827,41574,323438,8911,499808,749125,9176,439312,261531,35604,421994,170685,869057,716795,440822,993070,572513,447672,879277,899047,217741,514444,899066,752629,546008,1010576,639920,1021856,817118,727288,468950,788741,647870,666957,838665,482426,2803,5594,787032,964097,861917,131858,373688,411167,825951,512074,949031,608474,947857,662734,749017,833553,14918,279469,730401,627791,285471,902853,376387,141298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]