SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410291 LIMIT 1 [ RunTime:0.000900s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410291 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840142,452985,427832,747495,957615,418216,230039,241288,861041,722526,971117,920483,402533,441217,648033,591667,126180,386659,350453,232692,316639,390250,424396,401252,186330,967316,847476,836011,276263,318349,50967,193166,285992,223346,1027238,619968,208661,13928,283005,198436,257481,609153,48714,720677,870419,446250,900063,982800,975141,693693,767364,445513,747899,80190,670783,505740,714040,668130,505341,1016680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001908s ]