SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484341 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484341 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975618,693907,827412,1043002,278187,747882,295286,201368,552647,720217,8227,811320,291273,505605,899257,835005,789207,710898,306236,33439,564542,575851,756702,1026924,388101,262307,32944,789490,669919,879470,717165,888806,850281,619783,85170,529721,351747,484753,636477,839377,284030,848245,38100,1031198,713209,803721,973344,95202,143206,22949,121612,166222,561526,535476,210685,933416,265877,943809,471897,877110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004059s ]