SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467526 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467526 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516554,2009,146058,254801,574778,50372,63315,948884,654263,1027778,275153,352160,873088,754755,888972,188741,632960,580604,362337,861575,397734,1011391,466695,991411,845594,917010,895460,411671,935153,390251,572118,680345,651450,134414,1002322,530788,559710,982311,983607,653767,217136,966678,585075,608057,602366,923496,618724,374275,946750,683346,45712,224305,70141,37806,694647,949567,1004419,132947,269865,305541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]