SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68740 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68740 [ RunTime:0.002968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112183,329307,208890,100463,936283,185703,280143,920791,439627,645718,303376,641675,870721,587088,55707,265816,1017301,255827,394981,401138,839499,676753,130359,108229,962786,398244,744389,220398,176124,931721,87122,626838,204140,205594,594502,425992,194538,798441,352707,93827,519453,724162,418218,155829,605241,787463,276600,569396,60627,146371,841686,164041,382836,11703,599319,615931,290674,504066,697155,867376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]