SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203150 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203150 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403067,69621,100895,284239,994008,573998,5302,375876,578732,97490,89422,18582,355820,239893,572481,616741,1044537,753464,171521,625699,810596,442518,683258,58372,931685,237589,422385,78353,37377,881522,225485,296533,149388,435969,715038,625152,843350,301105,466630,873236,130567,799069,14912,468481,729071,995434,38633,484580,43626,509750,365665,204073,315705,800790,470532,6550,603472,139545,395323,587403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]