SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541850 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541850 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559013,108820,713031,846719,169099,14250,405402,171772,340100,710597,732209,799285,72981,171676,599749,1008897,234265,343341,736156,473139,612664,732119,459902,239966,499151,902701,487685,79835,711738,905830,516227,36542,390643,722240,270460,378719,208010,403941,697890,217186,839574,245965,768535,239926,920294,527248,548214,523952,461682,450163,762613,132639,372990,413406,528576,148082,334054,613286,645552,158457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]