SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046544 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046544 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218150,44727,329920,460619,121686,829913,1009242,832117,416910,121728,222492,275663,13639,323950,980744,288954,130307,966725,917277,290375,949560,125863,563640,587585,117981,68467,984412,377715,37516,952470,692424,237685,716740,783411,629210,1020921,852819,451367,196897,534050,501308,199606,1004145,579247,276065,962353,833347,53758,88278,957063,57716,703050,857659,1003822,771266,440798,973983,45111,810185,608738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]