SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503909 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503909 [ RunTime:0.003624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117628,93522,580400,973139,455851,93683,39057,32768,789548,286670,99384,1004999,786583,840388,430069,161610,882006,837344,528,79377,317991,73010,919828,676683,211996,532500,709265,949450,123704,502936,869227,925394,740820,74467,76819,664829,240880,124682,125117,252926,136685,512484,930078,90408,434,517675,295242,204027,736334,983162,917921,181128,595731,660066,731445,508760,936284,262513,21170,306195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]