SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264074 LIMIT 1 [ RunTime:0.001161s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264074 [ RunTime:0.003973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42140,998744,689878,803885,324470,61693,125138,795225,51750,1011721,350318,905560,997569,32595,213621,601375,707603,913478,937956,379990,85440,430250,473510,522628,588190,145747,753060,497036,5955,991798,811904,690430,486827,262105,352196,283426,702010,1044624,27762,263517,893193,116372,91419,104191,915958,397108,439861,1032916,265001,726083,319563,306355,157776,268329,774849,25103,162498,378236,260600,334286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000870s ]