SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023352 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023352 [ RunTime:0.002576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924772,1025745,482791,182270,3579,515462,824243,652915,186666,372097,541998,591624,285051,780559,758012,486062,742555,921751,568198,299754,977742,237444,462283,498738,647682,874511,828642,680749,155448,459497,487320,927112,1001379,141855,675726,173024,322019,479228,59342,520266,488089,466824,368924,169157,588495,626340,611197,652052,377414,1018789,495877,28924,6925,405111,640468,694330,619495,660426,69281,989911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]