SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539421 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539421 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992082,788310,361290,687160,170642,919097,651455,171118,1000289,106461,740068,196742,53719,31899,862021,282585,237245,611600,385645,764632,1001026,324639,997008,385643,831462,280574,431002,409318,678780,973100,354385,566056,616784,830058,587866,245766,820908,559670,5185,960026,81951,981140,418488,1035226,371271,974506,202659,649156,259449,385820,90205,1015266,86693,522022,40565,876254,714541,821907,341119,587914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]