SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410505 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410505 [ RunTime:0.004560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964574,173693,198858,964622,496752,678253,220287,1001810,892772,777892,148049,832616,621346,254355,674904,690835,923370,863706,1004005,688191,775207,602442,235449,205035,615278,347965,108344,607131,418568,445211,404625,525958,865416,988450,294075,766889,31307,230857,179195,820429,462959,646774,882041,574505,354111,642538,1018925,14272,782067,471754,899870,873137,377337,589377,203704,467868,866820,66108,546324,870791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]