SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502538 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502538 [ RunTime:0.005198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648155,662521,528162,929667,1011867,612294,682141,1028533,436793,496359,107929,940759,788987,735794,197100,945080,40073,909313,997378,599078,227611,677972,735866,531540,406910,137726,703272,819752,192932,944875,995637,257405,658566,987444,566859,711739,351156,922583,958288,30761,418283,649196,581682,707777,551268,624017,185752,616873,595974,797563,795186,370104,492845,444314,736104,531882,41793,1029167,505948,953829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000354s ]