SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332853 LIMIT 1 [ RunTime:0.001648s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332853 [ RunTime:0.005213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943464,89818,102156,196393,205870,535287,607538,240150,963080,643729,531734,357023,487343,254078,691393,1011300,335675,1000759,1033840,4574,92504,760649,903564,1010782,625534,513008,853006,636960,621434,168134,1011911,1007112,195293,652451,666181,260164,703109,261444,287156,658624,166098,424363,250900,621437,950572,38362,495649,488298,949585,264185,43289,614482,348433,160483,692986,1004062,736278,252214,39157,92797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]