SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 768983 LIMIT 1 [ RunTime:0.001659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 768983 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927281,860319,228901,344535,244385,166823,547758,1040482,955311,671667,197335,324190,645829,112001,602151,552458,613958,1034899,347396,117327,300155,555479,259354,685949,424289,729698,95726,775219,1042321,510796,334387,866994,935709,157770,692601,812760,268719,551780,890735,256845,826375,174434,595977,171442,156943,560839,550532,488170,160694,490878,553461,884410,828412,247860,906942,233966,412013,635261,552124,532436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 768983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 768983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003563s ]