SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497064 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497064 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531997,913320,503381,34914,773095,322597,943092,1020599,565200,587808,775022,730925,16567,399366,994140,524330,57066,360753,566488,15664,859574,21294,1023913,558627,954539,403433,250713,228295,968813,439079,403214,441914,898924,289632,799927,82574,103828,62165,681990,862050,549388,67027,100583,1047690,220788,131722,625034,504269,104428,745874,1020398,946881,554446,613993,576891,894172,818300,187480,19313,851630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]