SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294991 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294991 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493917,262144,556502,967205,644311,507249,425847,88689,268147,868433,642321,4243,197181,483873,51665,476427,114637,685632,261054,186489,954940,919089,595556,322562,1000766,534601,591108,639268,113816,917151,32283,300418,600680,545596,165237,750122,283981,269962,266086,382447,437664,201405,346127,115163,614352,852670,835928,504546,30892,107422,718488,480863,995836,411441,913818,1042001,769281,438735,948620,575743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]