SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493533 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493533 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625574,282501,1016108,76514,342852,459044,714210,96421,114597,856129,721112,882022,1044681,308650,435837,550951,960993,622306,23841,123540,129564,816522,654618,477378,253639,426700,297919,1038007,1037277,515165,383282,476143,1048624,321701,273455,756761,431678,978567,740164,1037498,147681,439849,778163,1003338,977780,920304,474879,695666,1007195,403318,477099,151813,173000,1041088,662775,650733,585292,351568,30250,248940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001435s ]