SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566813 LIMIT 1 [ RunTime:0.000677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566813 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152061,69420,304879,943998,57121,622268,674716,687574,478989,325869,233287,730519,400378,812262,86284,930336,415509,62872,12220,846390,736957,908226,169244,569314,867520,353803,820574,873812,553642,117670,368169,499139,218043,100642,969762,252329,54078,92206,894360,269367,202194,582714,300227,81356,999229,1021492,138651,328478,225551,61085,100831,424692,806338,87039,156203,173103,1025854,647733,383983,89446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]