SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103438 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103438 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434072,565525,448765,762877,1027487,120298,80479,245491,809046,212702,149683,1016266,722724,392216,13334,56903,688194,704648,811106,24430,847184,507488,176029,253757,762787,573459,347468,493659,350874,666523,295274,29626,270879,710790,291542,517735,59145,484999,488640,365511,855419,459475,413668,73934,194282,316603,1007432,888263,169818,1016804,507146,262639,277310,24572,646188,859281,269048,949224,125466,776938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]