SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419416 LIMIT 1 [ RunTime:0.001203s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419416 [ RunTime:0.004611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690836,309248,163286,720699,290570,966180,699717,359640,520787,534332,157173,710825,583118,759661,330502,396521,381116,852442,552765,1004827,196404,197194,1027429,792007,773571,642429,991954,815441,386562,45551,555051,927910,1008680,112373,1007054,757942,415518,402232,52190,566025,272857,899426,90092,659065,752653,424972,650168,797857,627935,748063,878542,786343,802728,326853,89399,610804,654436,769142,336468,121084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]