SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576855 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576855 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189985,930290,718286,760738,769387,630770,946544,987970,676380,499023,861954,608285,280627,849613,517945,96820,648080,810943,544771,871252,622392,744812,972791,814842,825465,452548,905477,159388,903430,187814,721503,159821,22322,376060,688061,201830,650764,491081,995553,924158,640767,114938,661909,399459,917572,78845,669480,649252,192306,175207,633786,412028,477172,889926,304702,591175,353934,134873,33870,212568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576855 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576855 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002953s ]