SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142798 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142798 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968126,498521,116589,777186,762560,443030,790293,975597,1004450,978060,1005575,457300,603088,253457,13542,292003,1015422,229404,891992,890054,678315,633432,497374,145129,495705,26262,327638,264896,899703,754379,22438,159779,965295,360935,238170,122683,825079,235048,204032,311760,732378,353490,503345,981387,367352,413925,232178,104868,244850,820366,653874,711510,1047838,35067,190909,314416,15040,1031025,525726,430211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004258s ]