SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549039 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549039 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556278,22335,20548,833940,233230,656819,272445,693411,99331,28765,310634,604018,215381,896859,532117,400626,855383,1027389,578477,141883,177264,847873,36379,263696,1001924,16636,489089,991658,1039796,694142,218257,612656,985386,226541,722478,980566,861945,1028609,117677,78,921487,747583,484639,1022294,260058,339834,294136,1025595,568876,41774,691615,776272,259918,302570,554085,444454,766172,231913,334226,92245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]