SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508320 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508320 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682038,206231,425203,926861,688658,578569,889449,97507,115472,523504,221424,113362,238668,276073,518376,1019416,662210,583909,682050,209174,274782,875243,952530,451470,514575,814024,19425,817155,151656,77729,640596,1021437,932544,557972,209331,321434,42395,237532,227955,338319,1003506,126700,881638,961610,704853,877296,237183,295749,1047834,944420,389057,260440,34022,76279,990816,968206,647574,568622,96162,905537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]