SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416061 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416061 [ RunTime:0.002651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830422,622261,715630,965405,503146,769037,620907,440288,318062,358391,376887,25372,520688,675187,4867,227402,1003434,789300,1041992,42758,622865,251955,706946,4321,594483,888337,1000651,2403,518578,1040011,23361,700657,789003,197216,199502,814327,512008,887176,48867,282473,736486,522681,151533,807120,319488,785473,690951,477187,301090,286711,498383,555907,672470,736628,625539,680303,636476,733771,686556,825040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]