SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101907 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101907 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985583,219266,325547,887905,972,171200,651885,213303,163705,561531,311813,374233,807034,30209,805023,452130,1041457,538701,1014745,751046,891174,649029,583617,17734,933083,713041,294701,235050,420512,185951,795373,89883,30201,176741,869938,257261,863682,613934,966547,517538,516854,539642,650922,955270,343904,836374,700735,756638,8468,69892,265887,592568,59213,484908,920188,640502,675342,30783,715331,673053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]