SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573518 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573518 [ RunTime:0.002988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935806,1021531,277854,560534,335611,471233,526842,314644,670341,519507,262742,235805,940570,637210,699469,258013,987924,330987,552117,875701,391249,355754,831540,698984,874798,999996,493354,94946,325579,707187,666690,837028,933030,768829,800646,125392,571257,500088,972871,370187,195851,246560,360153,606029,584354,506523,698184,402087,319459,964053,475579,754484,1012057,789239,801171,404418,480000,725327,129765,671501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001012s ]