SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164895 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164895 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555962,256267,284738,959607,2354,1036741,231318,207662,692544,388760,195893,502136,277571,939875,447120,1034017,524317,585675,497352,652419,144357,504079,542871,616632,385286,576666,480845,33361,831064,988182,72030,1016518,981794,555301,523583,245190,953711,257384,106034,1011746,353488,31753,1035387,357473,200229,495888,242694,676134,298712,934139,927891,446431,641795,622243,735660,57168,304237,175853,522036,330755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]