SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390843 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390843 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622923,427279,385612,799389,106414,970408,527045,1001981,608608,417607,581526,286841,635294,770827,17253,304479,654757,1015457,363636,562509,945341,184497,734964,71772,650126,175114,504210,639740,678387,468163,368568,645144,897563,201102,233295,409999,704128,496178,265417,718938,470016,967835,578069,572010,757734,159017,274061,578644,16770,190948,416070,228833,268717,208543,674278,469745,4148,223383,354494,606797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]