SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543457 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543457 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688655,863474,566811,307897,730924,268262,854428,120071,558580,935075,100108,55475,242739,421378,307713,562593,595837,1004183,799151,327771,546715,64231,231379,81389,1024596,670342,195159,962397,401865,37555,214999,581086,400092,553033,10003,617484,851717,828001,1025074,634684,499608,114494,480587,477970,863418,215225,771880,356671,964617,647170,722048,195755,340609,305839,479176,919314,813159,541986,341647,945642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]