SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396221 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396221 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000270,1032062,763937,439805,664912,699209,344368,48127,457000,399828,315535,988220,778814,591747,959393,188423,877286,1030871,57324,833762,768830,874628,996625,26911,591465,986185,952093,322887,210835,239163,251862,136588,415985,149079,478681,335737,603399,592737,122475,594715,1045878,42615,577227,669867,593872,471657,368786,123296,531590,76875,466517,193574,978258,454990,171803,378887,464043,1017728,160782,799074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]