SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020411 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020411 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484147,317804,117700,79820,587513,317154,988560,335768,472119,959000,60084,186313,808838,945603,579226,415701,903304,340907,954188,124267,1022714,153036,510863,73905,784780,33785,141330,705109,576953,636228,233269,854828,693838,391906,187343,215554,635218,943276,361541,619671,852066,233827,730228,229913,232323,437935,335674,96415,85972,749715,485178,665982,373222,875483,180146,603661,128631,124980,134179,779296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]