SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418344 LIMIT 1 [ RunTime:0.005071s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418344 [ RunTime:0.008795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476305,789140,117095,514425,263012,946517,833661,483529,456285,240261,962636,44089,166382,680247,4984,11561,777333,674046,235972,824055,248900,327028,654773,225886,739439,920601,855596,61350,788601,14397,472146,472733,501147,402601,813035,432029,863904,57503,628153,56717,472384,6228,516094,151919,1027699,218556,335390,13662,248888,541259,375378,1001958,108807,947651,820341,180332,215520,750461,355175,636190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001305s ]