SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010860 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010860 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520093,13972,477086,403441,386419,127827,949923,14077,318138,956565,57684,767687,389665,175151,487104,190894,965981,18328,226691,108133,909029,208257,15102,647122,446280,651263,265120,421621,33499,525373,981348,676793,910963,374078,964432,710584,686751,259145,868094,48875,464514,1016661,480724,908112,423313,1019721,868101,225379,83438,1042896,348729,500997,239454,636480,513808,665894,599947,651781,911307,730821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]