SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420595 LIMIT 1 [ RunTime:0.001917s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420595 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581560,377826,332952,49695,997897,618535,262018,240181,914881,767438,239085,640373,871575,57708,393356,850603,87571,505297,1018417,211241,420996,315218,283769,389025,785838,290139,539133,98938,145825,788853,110997,1023928,520981,231462,966574,163839,422803,584119,44697,346513,412507,419780,831336,63746,810317,896738,226353,941812,302291,731162,249236,701063,312486,700440,1004843,866883,363249,923000,882879,423237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001629s ]