SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984321 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984321 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20527,103380,291704,804765,218149,716919,374960,519939,1096,428934,325729,1004123,799890,1033850,323378,50557,947054,661113,909452,320440,228305,494489,342721,699174,842935,778829,6872,453979,160066,425046,590121,341605,538841,861259,614575,263319,573905,577871,46272,539578,68126,687846,221777,391080,212851,267861,652673,850941,873998,603348,391868,137867,687043,616471,392063,494082,879117,967550,411978,910755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]