SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414958 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414958 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103340,659737,752774,367802,298212,422841,490793,981105,786886,911894,675351,845216,907448,760152,171115,714310,59858,372787,171961,416514,96173,990954,174082,143446,1046371,630931,255128,732996,1699,728166,414045,572552,628761,824224,554077,10407,706662,628489,1006537,721294,58539,809323,221062,14453,934436,620628,139546,424752,570100,346409,534151,296948,488969,397118,149640,760662,479106,145810,396005,1002151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]