SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407822 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407822 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564015,563302,873164,77136,882092,760551,940609,474647,988208,939401,573545,1011757,774888,1009346,376823,714121,855883,422287,778755,871700,281449,76057,667044,884765,136198,579127,222729,748905,882214,262353,711392,415739,102313,603206,845123,833893,15448,216822,271933,847561,559326,1039898,130729,286215,60323,128971,35059,231353,814287,1019216,731193,560997,592258,745691,289132,882685,425846,377394,499166,287720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]