SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341005 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341005 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8478,574352,768697,736024,107197,770850,163193,293492,993200,926930,396687,399839,756641,641224,888391,1042215,482574,816861,333817,216544,1012219,157827,28565,181332,686316,131293,221474,1019811,684753,180344,800218,642409,213320,631181,724354,498234,32765,350925,296091,146257,157621,706316,482612,706704,562409,884534,786159,804722,964164,677405,301744,221239,279694,159681,658961,391443,167995,819887,136466,647142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]