SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005094 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005094 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365166,183196,703000,304378,520368,777103,896508,898579,920016,330071,155393,564968,1017758,904416,508639,378270,309046,365109,424035,473243,834775,16845,168794,572535,249795,958896,606219,181866,296928,663446,956132,938159,222196,977624,171912,41827,288275,467491,523170,140627,110975,701570,387057,592290,121196,193891,92949,1012794,930810,856117,670474,217572,314954,34047,334026,325600,455690,802932,111223,474207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]