SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503081 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503081 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430663,297889,788568,570174,889705,25420,878014,23195,795740,522551,490518,1039526,719882,1002077,207446,565857,380864,32608,1033491,912513,865288,798093,973306,625097,519708,489977,564428,554321,159916,376013,890586,971682,4466,259880,960061,373434,847467,167508,737844,647749,161047,7660,790863,7175,556830,482389,184108,646521,1029984,948583,985058,189932,533659,756424,841492,78649,92951,259071,865773,540837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]