SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101033 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101033 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283195,578490,706899,653145,12575,906541,963976,670948,566621,568729,293805,131907,255920,282692,579299,1042523,439451,503133,985850,855614,153129,766773,819905,566696,1008558,189143,885358,112302,110233,551729,673304,677178,154213,573770,584996,449137,20876,597629,369013,520299,797621,711360,937166,277822,908483,130702,237131,457474,734483,298289,728668,241179,831549,376208,681988,100693,560918,172339,776075,868746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]