SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443817 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443817 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12004,772773,320118,536743,1020238,505099,653871,1023110,312659,170594,569084,640762,935672,979785,843483,40411,212080,737326,204683,1268,623546,409479,380187,320699,345926,526084,767758,167905,428717,428399,409835,161244,943090,739134,389573,301007,523764,41263,654176,228810,1002081,702390,758621,520018,813047,802326,496483,122617,19372,828554,576808,190270,766643,985858,810857,442875,240251,388230,108893,422600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]