SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101683 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101683 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016620,92812,89079,402824,770650,708946,922630,83542,498711,1017651,650791,984463,63489,673768,491017,978024,932505,497575,117386,7268,681573,668985,481878,153721,934021,112406,293535,442491,806419,574199,521549,965312,321238,798315,661444,73230,281857,733613,1015928,378516,817958,354644,865786,1016735,271044,225216,812584,796130,676841,1015406,136255,249157,399356,558721,147241,694777,643065,721454,414974,38670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]