SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040899 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040899 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469170,663283,161852,220180,670052,1034818,502280,504572,34716,711817,42840,980594,482192,221794,375559,723117,361213,881901,911029,888025,89240,757298,619896,659170,700094,187106,350236,21402,156105,629029,698989,614524,252935,443465,750627,757069,988473,460331,1033485,73389,544735,930217,20786,554488,17776,45662,685366,404592,937922,473410,323916,755005,842175,795003,420654,161932,457536,197201,893413,992936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000999s ]