SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506188 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506188 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669935,70713,82963,901277,412095,88101,970459,770791,919571,750483,626291,33855,945203,427417,67499,829602,917450,965778,268796,551434,894758,196305,455111,901179,180108,649881,585438,190352,1044416,847775,480127,785875,205110,771215,210231,998339,770590,485384,1013754,527050,227183,727273,225188,231765,648837,309972,133536,532470,1031055,14251,28674,253570,12715,483042,161339,115989,29173,531470,1013172,131812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]